Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Scratch Bot -- BAQ

Home Register
Log In
By Scratch Bot -- BAQ
parshooter
9/14/2023
12:57:13 PM
Any suggestions for BAQ and Belmont at the Big A?

Having trouble getting scratch bot to work for this listing.


Reply
jeff
9/16/2023
2:01:10 AM
Looks like NYRA asked Equibase to use BELMONT AT THE BIG A as the track_name instead of AQUEDUCT.

Screenshot of the Track Abreviations Table Interface with the correct entries and the xml shown in the background:

Scratch BOT entries for AQU




• Correct entries (if you are using HDW data) to persist in the Track Abbreviations Table Interface for the AQU 2023 Fall Meet:

Track Code: AQU
Tote Code: AQU
Notes: BELMONT AT THE BIG A




• The rules:

1. Persist the first 3 characters of the data file name to the Track Code and Tote Code fields.

2. Persist the track_name displayed in the xml to the Notes field.

That's It!




-jp
.

Reply
parshooter
9/18/2023
10:53:07 AM
Thank you. Have made the change.

Reply
jeff
9/21/2023
11:22:23 AM
Just a heads up...

Currently, the Equibase Racing Dates page lists 11-02-2023 as opening day for the AQU Fall Meet. Link, here.

Based on that, I expect Equibase to change the track_name in the XML back to "AQUEDUCT" (without the quotes) on or about 11-02-2023.

If and when that happens our first clue will be AQU is running a card and Scratch BOT is processing zero scratches and changes for AQU.

The same rules that I posted above still apply.

• The rules:

1. Persist the first 3 characters of the data file name to the Track Code and Tote Code fields.

2. Persist the track_name displayed in the xml to the Notes field.



-jp
.



Reply
parshooter
9/21/2023
11:22:59 AM
Jeff

I have made the change, but for whatever reason scratch bot for BAQ or AQU still does not work.

Reply
jeff
9/25/2023
11:13:19 PM
Just now seeing your post (Mon 09-25-2023 about 9:00 pm pacific time.)

Shoot me a copy of your c:\2004\JCapper.mdb file.

Attach it to an email or use the free area of the https://WeTransfer.com site to send it to me.

I'll have a look at the settings for AQU in your TrackAbbreviations table, make the needed correction, and email the file back to you.


-jp
.

Reply
jeff
9/27/2023
8:22:52 AM
JCapper.mdb file received in good order.

Looked inside. The track_name persisted in the Notes field of the TrackAbbreviations table is incorrect:

"BELMONT AT BIG A" (without the quotes.)

The correct track_name that needs to be persisted in the Notes field of the TrackAbbreviations table is:

"BELMONT AT THE BIG A" (without the quotes.)



-jp
.

Reply
jeff
11/2/2023
12:47:57 PM
Aaaaand now that Belmont's original dates have been completed... effective Thursday 11-02-2023:

Equibase has changed the track_name in the xml from "BELMONT AT THE BIG A" (without the quotes) to "AQUEDUCT" (without the quotes.)

screenshot:
AQUEDUCT



The correct entry in Scratch BOT's Track Abbreviations Table Interface for AQU is:

Track Code: AQU
Tote Code: AQU
Notes Field: AQUEDUCT



-jp
.



Reply
Reply

Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com